Views [dbo].[vSoftCredit]
SQLServer > iMIS1521GA > Views > dbo.vSoftCredit
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:39 PM Friday, January 07, 2011
Last Modified1:49:33 PM Thursday, September 22, 2011
Columns
Name
ID
AMOUNT
Permissions
TypeActionOwning Principal
GrantDeleteIMIS
GrantInsertIMIS
GrantReferencesIMIS
GrantSelectIMIS
GrantUpdateIMIS
SQL Script
create  view vSoftCredit as
    select ts.SOFT_CREDIT_ID as ID,
           sum(ts.AMOUNT) as AMOUNT
    from Trans_SoftCredit ts
group by ts.SOFT_CREDIT_ID

GO
GRANT REFERENCES ON  [dbo].[vSoftCredit] TO [IMIS]
GRANT SELECT ON  [dbo].[vSoftCredit] TO [IMIS]
GRANT INSERT ON  [dbo].[vSoftCredit] TO [IMIS]
GRANT DELETE ON  [dbo].[vSoftCredit] TO [IMIS]
GRANT UPDATE ON  [dbo].[vSoftCredit] TO [IMIS]
GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved